<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>后台管理</title>
<style type="text/css">
p {
	font-family: "华文行楷";
}
p {
	font-size: 16px;
}
p {
	color: #60F;
	font-family: "华文行楷";
	font-size: 18px;
}
body center {
	color: #630;
}
</style>
</head>
<body background="images/21.jpg">
<table width="100%" border="0" align="center" cellspacing="0">
  <tr>
    <td colspan="2" align="center">&nbsp;
      <p>水调歌头·明月几时有</p>
      <p>宋代:苏轼</p>
      <p>丙辰中秋，欢饮达旦，大醉，作此篇，兼怀子由。</p>
      <p>明月几时有？把酒问青天。不知天上宫阙，今夕是何年。我欲乘风归去，又恐琼楼玉宇，高处不胜寒。起舞弄清影，何似在人间？(何似 一作：何时；又恐 一作：惟 /   唯恐)<br />
    转朱阁，低绮户，照无眠。不应有恨，何事长向别时圆？人有悲欢离合，月有阴晴圆缺，此事古难全。但愿人长久，千里共婵娟。(长向   一作：偏向)</p></td>
  </tr>
  <tr>
    <td width="0%" rowspan="2" align="center">&nbsp;</td>
    <td width="100%" align="center">&nbsp;</td>
  </tr>
  <tr>
    <td align="center" valign="top"><table width="100%" align="center" cellspacing="1" bgcolor="#666633">
  <tr>
    <td width="17%" height="51" align="center" bgcolor="#FFCCFF">用户名</td>
    <td width="19%" align="center" bgcolor="#FFCCFF">密码</td>
    <td width="19%" align="center" bgcolor="#FFCCFF">性别</td>
    <td width="27%" align="center" bgcolor="#FFCCFF">邮箱</td>
    <td bgcolor="#FFCCFF">&nbsp;</td>
  </tr>
</table>
<p>
<?php
include("conn.php");				//包含conn.php文件
$arr=mysql_query("select * from tb_user",$conn);	//查询数据
/*使用while语句循环mysql_fetch_array()函数返回的数组*/
while($result=mysql_fetch_array($arr)){
?>
<table width="100%" border="0" align="center" cellspacing="1" bgcolor="#333300">
  <tr>
    <td width="17%" height="53" bgcolor="#FFFFFF">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $result['name'];?></td>
    <td width="19%" bgcolor="#FFFFFF">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $result['pwd'];?> </td>
    <td width="19%" bgcolor="#FFFFFF">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $result['sex'];?></td>
    <td width="27%" bgcolor="#FFFFFF">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $result['email'];?></td>
    <td width="9%" align="center" bgcolor="#FFFFFF"><a href="bs_update1.php?id=<?php echo $result['id'];?>">修改</a>
    <input type="hidden" name="id" value="<?php echo $result['id'];?>" /></td>
    <td width="9%" align="center" bgcolor="#FFFFFF"><a href="delete.php?id=<?php echo $result['id'];?>">删除</a></td>
  </tr>
</table>
<p>
  <?php
  }			//结束while循环    效果见图
?>
<tr>
    <td colspan="2" align="center"><font face="华文楷体" size="+5"><p>欢迎进入古风阁
  </tr>
</table>
<center>
<?php
include("conn.php");				//包含conn.php文件
$arr=mysql_query("select * from tb_news",$conn);	//查询数据
/*使用while语句循环mysql_fetch_array()函数返回的数组*/
while($result=mysql_fetch_array($arr)){
?>
   <tr><td height="25"><?php echo $result['name'];?>&nbsp;</td>
            <td><?php echo $result['news'];?>>              <!--输出新闻内容-->
            <span class="STYLE3">&nbsp;</span></td>
          <td><label>
            <input type="hidden" name="id" value="<?php echo $result['id'];?>" />
            <div align="center"><a href="bs_update.php?id=<?php echo $result['id'];?>">编辑</a></div>
          </label></td>
          </tr>
<?php
  }			//结束while循环   
?>	
<form id="form1" name="form1" method="post" action="backstage_ok.php">
<?php
include("conn.php");				//包含conn.php文件
$arr=mysql_query("select * from tb_news",$conn);	//查询数据
/*使用while语句循环mysql_fetch_array()函数返回的数组*/
while($result=mysql_fetch_array($arr)){
?>
   <tr><td height="25"><?php echo $result['name'];?>&nbsp;</td>
            <td><?php echo $result['news'];?>>              <!--输出新闻内容-->
            <span class="STYLE3">&nbsp;</span></td>
          <td><label>
            <input type="hidden" name="id" value="<?php echo $result['id'];?>" />
            <div align="center">
              <input name="Submit" type="submit" class="STYLE3" value="删除" />
              </div>
          </label></td>
          </tr>
<?php
  }			//结束while循环
?></form>	
<?php
                 include("conn.php");	        //包含conn.php文件
	$select=mysql_query("select * from tb_book");  //查询数据
	while($row=mysql_fetch_array($select)){	//循环输出查询内容
?>
     <tr>
          <td><?php echo $row['id'];?>&nbsp;</td>		<!--输出id-->
          <td><?php echo $row['name'];?>&nbsp;</td>		<!--输出书名-->
          <td><?php echo $row['pen'];?>&nbsp;</td>		<!--输出作者-->
          <td><?php echo $row['pub'];?>&nbsp;</td>	<!--输出出版社-->
          <td><?php echo $row['date'];?>&nbsp;</td> 	<!--输出出版时间-->
          <td><?php echo $row['rate'];?>&nbsp;</td> 	<!--输出价格-->
          <td><div align="center"><a href="bs_update.php?id=<?php echo $row['id'];?>">修改</a>
            <input type="hidden" name="id" value="<?php echo $row['id'];?>"/>
          </div></td>
     </tr>
<?php
	}
?>
</center>
<table width="100%" border="0" align="center">
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>